The coordinates of the Legionnairess Disease outbreaks will be used to gather weather data from surrounding stations. The averages of the data will be taken and outputted into a graph containing data from the last 10 years before the outbreak.
First I installed and downloaded the packages needed including rnoaa from github.
library(devtools)
install_github("geanders/rnoaa")
install_github("ropenscilabs/riem")
library(devtools)
library(rnoaa)
library(riem)
library(countyweather)
library(dplyr)
library(plyr)
library(tidyr)
library(weathermetrics)
library(ggplot2)
library(lubridate)
I created a data frame including the locations of each outbreak. I found the coordinates at http://maps.cga.harvard.edu/gpf/ and crossed checked them with Google coordinates. The other data in this set are year of outbreak and the year 10 years before the outbreak, onset date, and 14 days before the onset date.
| id | file_id | latitude | longitude | year_min | date_min | year_max | date_max | onset | before_onset |
|---|---|---|---|---|---|---|---|---|---|
| portugal | portugal | 38.96 | -8.99 | 2004 | 2004-01-01 | 2014 | 2014-12-31 | 2004-10-14 | 2004-09-30 |
| pittsburgh | pittsburgh | 40.43 | -79.98 | 2002 | 2002-01-01 | 2012 | 2012-12-31 | 2012-08-26 | 2012-08-12 |
| quebec | quebec | 46.85 | -71.34 | 2002 | 2002-01-01 | 2012 | 2012-12-31 | 2012-07-18 | 2012-07-04 |
| stoke-on-trent | stoke_on_trent | 53.02 | -2.15 | 2002 | 2002-01-01 | 2012 | 2012-12-31 | 2012-07-02 | 2012-06-18 |
| edinburgh | edinburgh | 55.94 | -3.20 | 2002 | 2002-01-01 | 2012 | 2012-12-31 | 2012-05-01 | 2012-04-17 |
| miyazaki | miyazaki | 31.89 | 131.34 | 1992 | 1992-01-01 | 2002 | 2002-12-31 | 2002-07-18 | 2002-07-04 |
| pas-de-calais | pas_de_calais | 50.51 | 2.37 | 1993 | 1993-01-01 | 2003 | 2003-12-31 | 2003-11-28 | 2003-11-14 |
| pamplona | pamplona | 42.81 | -1.65 | 1996 | 1996-01-01 | 2006 | 2006-12-31 | 2006-06-01 | 2006-05-18 |
| rapid city | rapid_city | 44.06 | -103.22 | 1995 | 1995-01-01 | 2005 | 2005-12-31 | 2005-05-26 | 2005-05-12 |
| sarpsborg | sarpsborg | 59.28 | 11.08 | 1995 | 1995-01-01 | 2005 | 2005-12-31 | 2005-05-12 | 2005-04-28 |
| barrow-in-furness | barrow_in_furness | 54.10 | -3.22 | 1992 | 1992-01-01 | 2002 | 2002-12-31 | 2002-07-30 | 2002-07-16 |
| murcia | murcia | 37.98 | -1.12 | 1991 | 1991-01-01 | 2001 | 2001-12-31 | 2001-06-26 | 2001-06-12 |
| melbourne | melbourne | -37.86 | 145.07 | 1990 | 1990-01-01 | 2000 | 2000-12-31 | 2000-04-17 | 2000-04-03 |
| bovenkarspel | bovenkarspel | 52.70 | 5.24 | 1989 | 1989-01-01 | 1999 | 1999-12-31 | 1999-02-25 | 1999-02-11 |
| london | london | 51.52 | -0.10 | 1979 | 1979-01-01 | 1989 | 1989-12-31 | 1989-01-01 | 1988-12-18 |
| sydney | sydney | -33.85 | 150.93 | 2006 | 2006-01-01 | 2016 | 2016-12-31 | 2016-04-25 | 2016-04-11 |
| genesee1 | genesee1 | 43.09 | -83.63 | 2004 | 2004-01-01 | 2014 | 2014-12-31 | 2014-06-06 | 2014-05-23 |
| genesee2 | genesee2 | 43.09 | -83.63 | 2005 | 2005-01-01 | 2015 | 2015-12-31 | 2015-05-04 | 2015-04-20 |
| columbus | columbus | 39.98 | -82.99 | 2003 | 2003-01-01 | 2013 | 2013-12-31 | 2013-07-09 | 2013-06-25 |
| bronx | bronx | 40.82 | -73.92 | 2005 | 2005-01-01 | 2015 | 2015-12-31 | 2015-07-12 | 2015-06-28 |
The next function will download information from all of the stations. It only needs to be downloaded once per session. It will take a couple minutes to download.
I created a loop to get a list of the stations within 30 km of the location.
station_data <- ghcnd_stations()[[1]]
df <- list()
for(i in 1:length(outbreak_loc$id))
{
df[[i]] <- (meteo_nearby_stations(lat_lon_df = outbreak_loc[i,],
station_data = station_data,
var = c("PRCP","TAVG","TMAX","TMIN",
"AWND","MDPR"),
year_min = outbreak_loc[i, "year_min"],
year_max = outbreak_loc[i, "year_max"],
radius = 30))
}
names(df) <- outbreak_loc$id
stations <- df
saveRDS(stations, file = "stations.RData")
stations <- readRDS("stations.RData")
stations
## $`barrow-in-furness`
## [1] id name latitude longitude distance
## <0 rows> (or 0-length row.names)
##
## $bovenkarspel
## id name latitude longitude distance
## 1 NLE00101917 ENKHUIZEN 52.6917 5.2944 3.780363
## 2 NLE00109144 HOOGKARSPEL 52.6867 5.1669 5.143626
## 3 NLE00101928 MEDEMBLIK 52.7781 5.1014 12.746887
## 4 NLE00100501 HOORN 52.6444 5.0681 13.136277
## 5 NLE00102479 BERKHOUT 52.6428 4.9789 18.718869
## 6 NLE00109146 HOOGWOUD 52.7281 4.9608 19.065006
## 7 NLE00109174 KREILEROORD 52.8619 5.0953 20.464698
## 8 NLE00102134 STAVOREN 52.8967 5.3831 23.894441
## 9 NLE00109232 OBDAM 52.6775 4.8769 24.600539
## 10 NLE00109054 EDAM 52.5114 5.0467 24.701897
## 11 NLE00109250 OUDEMIRDUM 52.8608 5.5078 25.379621
## 12 NLE00109162 KOLHORN 52.7914 4.8919 25.540549
## 13 NLE00109354 WEST BEEMSTER 52.5817 4.9028 26.281190
## 14 NLE00101948 TOLLEBEEK 52.6719 5.6300 26.472774
## 15 NLE00101930 DEN OEVER 52.9217 5.0383 28.133541
## 16 NLE00101932 MARKEN 52.4600 5.1078 28.142012
## 17 NLE00109028 DE HAUKES 52.8783 4.9408 28.246661
## 18 NLE00109254 PURMEREND 52.5125 4.9506 28.575998
##
## $bronx
## id name latitude longitude distance
## 1 USW00014732 NY NEW YORK LAGUARDIA AP 40.7794 -73.8803 5.616756
## 2 USC00305799 NY NEW YORK BOTANICAL GRD 40.8667 -73.8833 6.041176
## 3 USW00094728 NY NEW YORK CNTRL PK TWR 40.7789 -73.9692 6.167420
## 4 USC00300961 NY BRONX 40.8369 -73.8494 6.230297
## 5 US1NJBG0018 NJ PALISADES PARK 0.2 WNW 40.8481 -74.0002 7.435652
## 6 USC00305804 NY NEW YORK LAUREL HILL 40.7333 -73.9333 9.705430
## 7 US1NJBG0003 NJ TENAFLY 1.3 W 40.9147 -73.9775 11.587163
## 8 US1NYQN0002 NY MIDDLE VILLAGE 0.5 SW 40.7145 -73.8819 12.161951
## 9 USW00094741 NJ TETERBORO AP 40.8500 -74.0614 12.354793
## 10 US1NJBG0001 NJ BERGENFIELD 0.3 SW 40.9213 -74.0020 13.206762
## 11 US1NJBG0012 NJ WOOD RIDGE 0.6 SE 40.8420 -74.0830 13.930427
## 12 USC00284339 NJ JERSEY CITY 40.7419 -74.0572 14.452190
## 13 USC00284931 NJ LODI 40.8667 -74.0833 14.685375
## 14 US1NJBG0033 NJ WOOD RIDGE 0.6 NNW 40.8536 -74.0943 15.131881
## 15 US1NYWC0009 NY NEW ROCHELLE 1.3 S 40.9040 -73.7770 15.226895
## 16 US1NJBG0013 NJ RUTHERFORD 1.2 N 40.8373 -74.1065 15.809146
## 17 US1NYKN0025 NY BROOKLYN 3.1 NW 40.6846 -73.9867 16.069963
## 18 US1NJBG0031 NJ DEMAREST 0.6 NNW 40.9628 -73.9600 16.230719
## 19 US1NJBG0002 NJ SADDLE BROOK TWP 0.6 E 40.9027 -74.0834 16.534408
## 20 US1NJBG0011 NJ NORTH ARLINGTON 0.7 NE 40.7944 -74.1190 16.988985
## 21 US1NJBG0008 NJ SADDLE BROOK TWP 0.3 NNE 40.9071 -74.0934 17.505118
## 22 USC00286146 NJ NEW MILFORD 40.9611 -74.0158 17.635536
## 23 US1NJBG0015 NJ NORTH ARLINGTON 0.7 WNW 40.7915 -74.1398 18.769309
## 24 US1NJHD0002 NJ KEARNY 1.7 NW 40.7729 -74.1409 19.318492
## 25 US1NJBG0005 NJ WESTWOOD 0.8 ESE 40.9830 -74.0159 19.836072
## 26 US1NJBG0010 NJ RIVER VALE TWP 1.5 S 40.9915 -74.0123 20.587159
## 27 US1NYNS0007 NY FLORAL PARK 0.4 W 40.7230 -73.7110 20.642010
## 28 USC00307497 NY SCARSDALE 40.9833 -73.8000 20.770959
## 29 US1NJHD0001 NJ HARRISON 0.3 N 40.7480 -74.1518 21.094543
## 30 USC00286775 NJ PATERSON 40.9000 -74.1500 21.289996
## 31 USC00283704 NJ HARRISON 40.7514 -74.1567 21.338273
## 32 US1NJBG0020 NJ PARAMUS 1.8 NNW 40.9682 -74.0902 21.822558
## 33 USC00302129 NY DOBBS FERRY-ARDSLEY 41.0072 -73.8344 22.023427
## 34 US1NJBG0017 NJ GLEN ROCK 0.7 SSE 40.9511 -74.1183 22.145027
## 35 US1NJES0020 NJ BLOOMFIELD 1.7 S 40.7850 -74.1885 22.932509
## 36 US1NYKN0003 NY BROOKLYN 2.4 SW 40.6194 -73.9859 22.986706
## 37 US1NYWC0005 NY HARRISON 4.1 SSW 40.9639 -73.7232 23.014851
## 38 USC00307587 NY SEA CLIFF 40.8506 -73.6483 23.109762
## 39 US1NJBG0037 NJ GLEN ROCK 0.4 WNW 40.9614 -74.1328 23.815579
## 40 US1NJPS0014 NJ HAWTHORNE 1.0 SSE 40.9436 -74.1523 23.880745
## 41 USC00289832 NJ WOODCLIFF LAKE 41.0139 -74.0425 23.891667
## 42 US1NJES0015 NJ MONTCLAIR 2.2 NNE 40.8565 -74.2004 23.935385
## 43 USW00094789 NY NEW YORK JFK INTL AP 40.6386 -73.7622 24.159135
## 44 US1NJPS0017 NJ WOODLAND PARK 0.1 NW 40.8918 -74.1960 24.547061
## 45 USC00305382 NY MINEOLA 1 W 40.7333 -73.6500 24.694525
## 46 US1NJPS0005 NJ HAWTHORNE 0.4 S 40.9519 -74.1577 24.787058
## 47 US1NJES0011 NJ CEDAR GROVE TWP 0.9 NE 40.8648 -74.2157 25.368252
## 48 USC00305796 NY NY AVE V BROOKLYN 40.5939 -73.9808 25.658206
## 49 US1NJPS0018 NJ PATERSON 2.0 W 40.9163 -74.2005 25.903423
## 50 USW00014734 NJ NEWARK INTL AP 40.6825 -74.1694 25.982975
## 51 US1NJPS0003 NJ LITTLE FALLS TWP 0.2 NNW 40.8788 -74.2205 26.107408
## 52 USC00305380 NY MINEOLA 1 NE 40.7494 -73.6233 26.184670
## 53 USC00303786 NY HEMPSTEAD MALVERNE 40.6833 -73.6667 26.197491
## 54 USW00014786 NY NEW YORK FLOYD BENNETT FLD 40.5833 -73.8833 26.501042
## 55 USC00305821 NY NY WESTERLEIGH STAT IS 40.6333 -74.1167 26.565419
## 56 US1NJPS0012 NJ LITTLE FALLS TWP 0.5 WNW 40.8796 -74.2270 26.658883
## 57 USC00303781 NY HEMPSTEAD GARDEN CITY 40.7167 -73.6333 26.737225
## 58 USC00284887 NJ LITTLE FALLS 40.8858 -74.2261 26.764590
## 59 US1NJES0024 NJ CEDAR GROVE TWP 0.4 W 40.8557 -74.2356 26.845270
## 60 US1NYNS0014 NY LYNBROOK 0.3 NW 40.6623 -73.6780 26.891776
## 61 USC00285503 NJ MIDLAND PARK 40.9939 -74.1453 27.062890
## 62 USC00305377 NY MINEOLA 40.7328 -73.6183 27.191818
## 63 US1NJPS0004 NJ NORTH HALEDON 0.6 N 40.9713 -74.1856 27.953822
## 64 US1NJES0010 NJ VERONA TWP 0.7 SW 40.8255 -74.2531 28.035405
## 65 US1NJES0021 NJ VERONA TWP 0.6 WSW 40.8305 -74.2539 28.119240
## 66 US1NJES0004 NJ NORTH CALDWELL 0.6 SSE 40.8576 -74.2523 28.265572
## 67 USC00309117 NY WESTBURY 40.7333 -73.6000 28.617850
## 68 US1NJPS0008 NJ WAYNE TWP 1.1 ESE 40.9412 -74.2267 29.094312
## 69 USC00309270 NY WEST NYACK 41.0833 -73.9667 29.539139
## 70 US1NYWC0003 NY WHITE PLAINS 3.1 NNW 41.0639 -73.7722 29.826697
## 71 US1NYNS0009 NY MILL NECK 1.1 SW 40.8704 -73.5717 29.828998
## 72 US1NYRL0005 NY WEST NYACK 1.3 WSW 41.0835 -73.9930 29.934369
##
## $columbus
## id name latitude longitude
## 1 USW00093891 OH COLUMBUS WSO CITY 39.9667 -83.0000
## 2 US1OHFR0018 OH COLUMBUS 2.4 WNW 39.9977 -83.0323
## 3 US1OHFR0025 OH COLUMBUS 2.8 WSW 39.9804 -83.0397
## 4 US1OHFR0003 OH GRANDVIEW HEIGHTS 0.1 N 39.9810 -83.0401
## 5 USC00331782 OH COLUMBUS UNIV FARM 40.0000 -83.0500
## 6 USC00331785 OH COLUMBUS WCMH 40.0250 -83.0269
## 7 US1OHFR0039 OH COLUMBUS 3.4 WNW 40.0143 -83.0434
## 8 US1OHFR0034 OH COLUMBUS 3.6 NW 40.0191 -83.0437
## 9 US1OHFR0020 OH COLUMBUS 3.5 NE 40.0287 -82.9477
## 10 US1OHFR0001 OH UPPER ARLINGTON 0.9 E 40.0279 -83.0543
## 11 US1OHFR0021 OH MARBLE CLIFF 1.1 WNW 39.9931 -83.0786
## 12 US1OHFR0007 OH UPPER ARLINGTON 1.3 SSW 40.0112 -83.0832
## 13 USW00014821 OH COLUMBUS PORT COLUMBUS INTL AP 39.9914 -82.8808
## 14 USC00331783 OH COLUMBUS-VALLEY CROSSING 39.9047 -82.9200
## 15 USC00331781 OH COLUMBUS SULLIVANT AVE 39.9500 -83.1167
## 16 US1OHFR0012 OH UPPER ARLINGTON 2.4 NNW 40.0604 -83.0815
## 17 USC00331777 OH COLUMBUS-HAP CREMEAN WP 40.0603 -82.8942
## 18 US1OHFR0024 OH COLUMBUS 9.3 NNE 40.0925 -82.9582
## 19 USW00004804 OH COLUMBUS OHIO STATE UNIV AP 40.0781 -83.0781
## 20 US1OHFR0037 OH REYNOLDSBURG 1.6 W 39.9588 -82.8294
## 21 US1OHFR0016 OH DUBLIN 3.7 ESE 40.0923 -83.0725
## 22 US1OHFR0022 OH GALLOWAY 3.1 N 39.9561 -83.1592
## 23 USC00331779 OH COLUMBUS-PARSONS AVE. 39.8469 -82.9872
## 24 USC00338951 OH WESTERVILLE 40.1264 -82.9433
## 25 US1OHFR0010 OH WESTERVILLE 0.2 WNW 40.1226 -82.9213
## 26 US1OHFR0030 OH HILLIARD 1.8 W 40.0344 -83.1768
## 27 US1OHFR0008 OH NEW ALBANY 2.8 SSE 40.0403 -82.7980
## 28 US1OHFR0002 OH DUBLIN 3.2 ENE 40.1299 -83.0742
## 29 USW00013812 OH COLUMBUS RICKENBACKER 39.8167 -82.9333
## 30 US1OHLC0002 OH PATASKALA 4.4 WNW 40.0273 -82.7490
## 31 US1OHFF0010 OH PICKERINGTON 0.1 SSE 39.8895 -82.7680
## 32 US1OHFF0005 OH PICKERINGTON 2.7 NNE 39.9263 -82.7469
## 33 US1OHDL0002 OH WESTERVILLE 4.0 N 40.1790 -82.9256
## 34 US1OHDL0012 OH LEWIS CENTER 1.4 E 40.1967 -82.9835
## 35 US1OHDL0008 OH DUBLIN 3.7 NNW 40.1642 -83.1687
## 36 US1OHFR0023 OH HARRISBURG 3.7 WNW 39.8378 -83.2321
## 37 USC00334616 OH LITHOPOLIS 2 S 39.7833 -82.8167
## 38 USC00330083 OH ALEXANDRIA 4 WSW 40.0833 -82.6833
## 39 US1OHDL0013 OH GALENA 3.0 WNW 40.2337 -82.9362
## 40 US1OHLC0011 OH PATASKALA 2.0 NE 40.0240 -82.6511
## 41 USC00332170 OH DERBY 39.7667 -83.2000
## distance
## 1 1.706827
## 2 4.106137
## 3 4.234920
## 4 4.270197
## 5 5.574388
## 6 5.909011
## 7 5.936178
## 8 6.310790
## 9 6.504242
## 10 7.639623
## 11 7.687720
## 12 8.664212
## 13 9.389591
## 14 10.282003
## 15 11.301408
## 16 11.858973
## 17 12.094496
## 18 12.799033
## 19 13.238469
## 20 13.887609
## 21 14.326951
## 22 14.662096
## 23 14.801971
## 24 16.757176
## 25 16.900247
## 26 17.021110
## 27 17.673463
## 28 18.143413
## 29 18.791310
## 30 21.190424
## 31 21.436847
## 32 21.564691
## 33 22.796070
## 34 24.102284
## 35 25.509352
## 36 26.008132
## 37 26.401695
## 38 28.527330
## 39 28.578803
## 40 29.278406
## 41 29.727063
##
## $edinburgh
## [1] id name latitude longitude distance
## <0 rows> (or 0-length row.names)
##
## $genesee1
## id name latitude longitude distance
## 1 USC00201150 MI BURTON 4N 43.0675 -83.5919 3.979309
## 2 US1MIGN0010 MI BURTON 0.9 NNW 43.0085 -83.6274 9.064849
## 3 US1MIGN0008 MI MOUNT MORRIS 3.1 WSW 43.1057 -83.7580 10.538333
## 4 US1MIGN0014 MI DAVISON 3.3 SW 43.0003 -83.5684 11.159857
## 5 US1MIGN0005 MI DAVISON 0.7 SSW 43.0219 -83.5246 11.431375
## 6 USC00202851 MI FLINT 7 W 43.0378 -83.7694 12.725462
## 7 US1MIGN0024 MI CLIO 0.4 SW 43.1725 -83.7423 12.930649
## 8 USC00201645 MI CLIO 43.1794 -83.7369 13.193328
## 9 US1MIGN0009 MI BURTON 3.3 SW 42.9613 -83.6636 14.569099
## 10 USW00014826 MI FLINT BISHOP INTL AP 42.9667 -83.7494 16.797891
## 11 US1MIGN0023 MI GRAND BLANC 3.8 WNW 42.9440 -83.6886 16.919078
## 12 US1MISG0004 MI BIRCH RUN 2.6 ESE 43.2291 -83.7470 18.146491
## 13 US1MIGN0020 MI SWARTZ CREEK 2.0 NNE 42.9897 -83.8166 18.824526
## 14 US1MIGN0015 MI FLINT 6.4 SSW 42.9326 -83.7210 19.001794
## 15 US1MIGN0018 MI GRAND BLANC 0.7 SE 42.9187 -83.6079 19.132279
## 16 USC00203278 MI GOODRICH 42.9164 -83.5097 21.640755
## 17 USC00204659 MI LAPEER 2W 43.0581 -83.3606 22.167570
## 18 US1MIGN0022 MI GRAND BLANC 2.9 SE 42.8909 -83.5858 22.428899
## 19 USC00204662 MI LAPEER 4 SW 43.0081 -83.3750 22.633695
## 20 US1MIGN0004 MI MONTROSE 0.4 NW 43.1794 -83.8987 23.962697
## 21 USC00205488 MI MILLINGTON 3 SE 43.2836 -83.4792 24.756898
## 22 US1MILP0003 MI LAPEER 1.1 SSW 43.0316 -83.3293 25.277892
## 23 USC00201721 MI COLUMBIAVILLE 5 NE 43.1897 -83.3358 26.319366
## 24 USC00204655 MI LAPEER WWTP 43.0608 -83.3075 26.394851
## 25 USC00202955 MI FRANKENMUTH 1SE 43.3194 -83.7161 26.445482
##
## $genesee2
## id name latitude longitude distance
## 1 USC00201150 MI BURTON 4N 43.0675 -83.5919 3.979309
## 2 US1MIGN0010 MI BURTON 0.9 NNW 43.0085 -83.6274 9.064849
## 3 US1MIGN0008 MI MOUNT MORRIS 3.1 WSW 43.1057 -83.7580 10.538333
## 4 US1MIGN0014 MI DAVISON 3.3 SW 43.0003 -83.5684 11.159857
## 5 US1MIGN0005 MI DAVISON 0.7 SSW 43.0219 -83.5246 11.431375
## 6 USC00202851 MI FLINT 7 W 43.0378 -83.7694 12.725462
## 7 US1MIGN0024 MI CLIO 0.4 SW 43.1725 -83.7423 12.930649
## 8 USC00201645 MI CLIO 43.1794 -83.7369 13.193328
## 9 US1MIGN0009 MI BURTON 3.3 SW 42.9613 -83.6636 14.569099
## 10 USW00014826 MI FLINT BISHOP INTL AP 42.9667 -83.7494 16.797891
## 11 US1MIGN0023 MI GRAND BLANC 3.8 WNW 42.9440 -83.6886 16.919078
## 12 US1MISG0004 MI BIRCH RUN 2.6 ESE 43.2291 -83.7470 18.146491
## 13 US1MIGN0020 MI SWARTZ CREEK 2.0 NNE 42.9897 -83.8166 18.824526
## 14 US1MIGN0015 MI FLINT 6.4 SSW 42.9326 -83.7210 19.001794
## 15 US1MIGN0018 MI GRAND BLANC 0.7 SE 42.9187 -83.6079 19.132279
## 16 USC00203278 MI GOODRICH 42.9164 -83.5097 21.640755
## 17 USC00204659 MI LAPEER 2W 43.0581 -83.3606 22.167570
## 18 US1MIGN0022 MI GRAND BLANC 2.9 SE 42.8909 -83.5858 22.428899
## 19 USC00204662 MI LAPEER 4 SW 43.0081 -83.3750 22.633695
## 20 US1MIGN0004 MI MONTROSE 0.4 NW 43.1794 -83.8987 23.962697
## 21 USC00205488 MI MILLINGTON 3 SE 43.2836 -83.4792 24.756898
## 22 US1MILP0003 MI LAPEER 1.1 SSW 43.0316 -83.3293 25.277892
## 23 USC00201721 MI COLUMBIAVILLE 5 NE 43.1897 -83.3358 26.319366
## 24 USC00204655 MI LAPEER WWTP 43.0608 -83.3075 26.394851
## 25 USC00202955 MI FRANKENMUTH 1SE 43.3194 -83.7161 26.445482
##
## $london
## id name latitude longitude distance
## 1 UKM00003772 HEATHROW 51.478 -0.461 25.42177
##
## $melbourne
## id name latitude longitude
## 1 ASN00086141 BURWOOD PLC -37.8333 145.0833
## 2 ASN00086018 CAULFIELD (RACECOURSE) -37.8795 145.0368
## 3 ASN00086304 HAWTHORN (SCOTCH COLLEGE) -37.8361 145.0294
## 4 ASN00086019 CAULFIELD SOUTH -37.9000 145.0333
## 5 ASN00086060 KEW -37.8167 145.0333
## 6 ASN00086095 PRAHRAN (COMO HOUSE) -37.8376 145.0048
## 7 ASN00086088 OAKLEIGH (METROPOLITAN GOLF CL -37.9142 145.0935
## 8 ASN00086012 BOX HILL AGED MENS RETREAT -37.8364 145.1364
## 9 ASN00086002 BALWYN NORTH -37.8000 145.0500
## 10 ASN00086016 CANTERBURY -37.8000 145.0500
## 11 ASN00086222 SYNDAL CSIRO -37.8833 145.1500
## 12 ASN00086006 BENTLEIGH -37.9279 145.0749
## 13 ASN00086011 BOX HILL SOUTH -37.8333 145.1500
## 14 ASN00086033 BRIGHTON (DENDY PARK BOWLING C -37.9252 145.0254
## 15 ASN00086340 BLACKBURN -37.8167 145.1500
## 16 ASN00086232 MELBOURNE BOTANICAL GARDENS -37.8303 144.9767
## 17 ASN00086013 BURNLEY -37.8000 145.0000
## 18 ASN00086100 BURNLEY RICHMOND PARK -37.8000 145.0000
## 19 ASN00086307 ABBOTSFORD -37.8000 145.0000
## 20 ASN00086341 DONCASTER -37.7833 145.1167
## 21 ASN00086279 NORTHCOTE -37.7797 145.0314
## 22 ASN00086316 VERMONT TRANSPORT RESEARCH -37.8587 145.1847
## 23 ASN00086071 MELBOURNE REGIONAL OFFICE -37.8075 144.9700
## 24 ASN00086020 CHELTENHAM KINGSTON CENTRE -37.9551 145.0782
## 25 ASN00086317 SANDRINGHAM 2 -37.9500 145.0167
## 26 ASN00086031 DONCASTER -37.7833 145.1500
## 27 ASN00086303 GLEN WAVERLEY (GOLF COURSE) -37.8886 145.1928
## 28 ASN00086074 MITCHAM -37.8219 145.1906
## 29 ASN00086257 VERMONT SOUTH -37.8500 145.2000
## 30 ASN00086260 HEIDELBERG MMBW -37.7567 145.0533
## 31 ASN00086348 MULGRAVE -37.9167 145.1833
## 32 ASN00086047 GLEN WAVERLEY (SYNDAL) -37.9000 145.2000
## 33 ASN00086241 TEMPLESTOWE PASSIONATE FATHERS -37.7667 145.1500
## 34 ASN00086302 WANTIRNA SOUTH -37.8667 145.2167
## 35 ASN00086378 BRUNSWICK -37.7667 144.9797
## 36 ASN00086111 SPRINGVALE NECROPOLIS -37.9445 145.1764
## 37 ASN00086369 SPRINGVALE (SANDOWN) -37.9535 145.1655
## 38 ASN00086068 VIEWBANK (ARPANSA) -37.7408 145.0972
## 39 ASN00086077 MOORABBIN AIRPORT -37.9800 145.0964
## 40 ASN00086146 BEAUMARIS -37.9771 145.0273
## 41 ASN00086053 HEIDELBERG (ROSANNA) -37.7500 145.0000
## 42 ASN00086333 THORNBURY -37.7500 145.0000
## 43 ASN00087145 WILLIAMSTOWN BOWLING CLUB -37.8500 144.9000
## 44 ASN00086362 DONCASTER (MANNINGHAM DEPOT) -37.7494 145.1703
## 45 ASN00086024 COBURG -37.7500 144.9667
## 46 ASN00086263 MORDIALLOC NORTH -38.0000 145.1000
## 47 ASN00086351 BUNDOORA (LATROBE UNIVERSITY) -37.7163 145.0453
## 48 ASN00086039 FLEMINGTON RACECOURSE -37.7915 144.9067
## 49 ASN00086104 SCORESBY RESEARCH INSTITUTE -37.8710 145.2561
## 50 ASN00086096 PRESTON RESERVOIR -37.7214 145.0059
## 51 ASN00086230 BAYSWATER -37.8372 145.2558
## 52 ASN00086379 RINGWOOD NORTH -37.7917 145.2433
## 53 ASN00087022 FOOTSCRAY -37.8167 144.8833
## 54 ASN00086101 RINGWOOD -37.8000 145.2500
## 55 ASN00086313 WARRANDYTE -37.7469 145.2098
## 56 ASN00086284 LYSTERFIELD (ALBION REID) -37.9333 145.2500
## 57 ASN00086343 BUNDOORA -37.7000 145.0667
## 58 ASN00086122 WATSONIA LOYOLA -37.7000 145.0833
## 59 ASN00086347 YARRA RIVER @ WARRANDYTE -37.7417 145.2167
## 60 ASN00086091 PASCOE VALE -37.7333 144.9333
## 61 ASN00086224 DANDENONG -37.9785 145.2235
## 62 ASN00086035 ELTHAM -37.7011 145.1547
## 63 ASN00087038 MARIBYRNONG EXPLOSIVES FACTORY -37.7750 144.8767
## 64 ASN00086147 ASPENDALE CSIRO -38.0333 145.1000
## 65 ASN00086332 ESSENDON 2 -37.7333 144.9167
## 66 ASN00086046 GLENROY -37.7167 144.9333
## 67 ASN00086324 FERNTREE GULLY (PROBERT) -37.8797 145.2964
## 68 ASN00086027 CROYDON (SAMUEL STREET) -37.7903 145.2812
## 69 ASN00086010 BORONIA 1 -37.8500 145.3000
## 70 ASN00086215 DIAMOND CREEK -37.6833 145.1333
## 71 ASN00086234 CROYDON (COUNCIL DEPOT) -37.7869 145.2847
## 72 ASN00086038 ESSENDON AIRPORT -37.7276 144.9066
## 73 ASN00087131 ALTONA (CITY OFFICES) -37.8633 144.8261
## 74 ASN00086110 MORANG SOUTH -37.6667 145.0833
## 75 ASN00087148 SUNSHINE (CITY OF BRINBANK) -37.7928 144.8344
## 76 ASN00086355 PLENTY (DAPRANO) -37.6667 145.1333
## 77 ASN00086250 PLENTY -37.6600 145.1244
## 78 ASN00086286 GLENROY (EVELL STREET) -37.6833 144.9333
## 79 ASN00086256 FERNY CREEK -37.8833 145.3333
## 80 ASN00086292 BANGHOLME -38.0500 145.1833
## 81 ASN00086210 BONBEACH (CARRUM) -38.0651 145.1294
## 82 ASN00086372 FERNY CREEK (DUNNS HILL) -37.8775 145.3364
## 83 ASN00086228 KILSYTH (TUKAMUNDA) -37.8167 145.3333
## 84 ASN00086365 MOOROOLBARK -37.7792 145.3197
## 85 ASN00086251 UPWEY SHIRE COUNCIL -37.9144 145.3317
## 86 ASN00086270 SASSAFRAS (THE CRESCENT) -37.8667 145.3500
## 87 ASN00086221 SHERBROOKE BURNAM BEECHES -37.8833 145.3500
## 88 ASN00086243 MOUNT DANDENONG GTV9 -37.8306 145.3500
## 89 ASN00086059 KANGAROO GROUND -37.6830 145.2518
## 90 ASN00086258 BELGRAVE -37.9167 145.3500
## 91 ASN00086103 SASSAFRAS POST OFFICE -37.8000 145.3500
## 92 ASN00086254 CARRUM DOWNS SEWER WORKS -38.0783 145.1733
## 93 ASN00086036 EPPING -37.6312 144.9846
## 94 ASN00086287 HURSTBRIDGE (NORALA) -37.6500 145.2167
## 95 ASN00086066 LILYDALE -37.7488 145.3416
## 96 ASN00086076 MONTROSE -37.8019 145.3675
## 97 ASN00087020 DEER PARK -37.7667 144.7833
## 98 ASN00086085 NARRE WARREN NORTH (NARRE WARR -37.9897 145.3356
## 99 ASN00087031 LAVERTON RAAF -37.8565 144.7566
## 100 ASN00087027 KEILOR (ARUNDEL) -37.6942 144.8342
## 101 ASN00086056 KALLISTA FORESTRY -37.9000 145.3833
## 102 ASN00086086 NARRE WARREN (BRECHIN) -38.0333 145.3000
## 103 ASN00086319 DOREEN -37.6167 145.1500
## 104 ASN00087032 LAVERTON SALINES -37.9000 144.7500
## 105 ASN00087177 LAVERTON COMPARISON -37.8633 144.7456
## 106 ASN00086225 CARNEGIE -38.1167 145.0667
## 107 ASN00086305 GREENVALE RESERVOIR -37.6369 144.9072
## 108 ASN00086384 MELBOURNE AIRPORT COMPARISON -37.6750 144.8419
## 109 ASN00087015 KEILOR -37.7025 144.8072
## 110 ASN00087107 POINT COOK RAAF ACADEMY -37.9333 144.7500
## 111 ASN00087106 POINT COOK RAAF (DUNNINGS RD) -37.8833 144.7333
## 112 ASN00086107 SILVAN STATE SCHOOL -37.8000 145.4000
## distance
## 1 3.190327
## 2 3.632396
## 3 4.446429
## 4 5.491613
## 5 5.793822
## 6 6.243145
## 7 6.369850
## 8 6.393542
## 9 6.899047
## 10 6.899047
## 11 7.484784
## 12 7.562369
## 13 7.626099
## 14 8.238821
## 15 8.516796
## 16 8.833034
## 17 9.072309
## 18 9.072309
## 19 9.072309
## 20 9.463805
## 21 9.551015
## 22 10.070617
## 23 10.545355
## 24 10.599081
## 25 11.046224
## 26 11.050534
## 27 11.237859
## 28 11.406147
## 29 11.467486
## 30 11.579751
## 31 11.773203
## 32 12.245870
## 33 12.530662
## 34 12.899710
## 35 13.059611
## 36 13.245203
## 37 13.352636
## 38 13.468157
## 39 13.542852
## 40 13.548961
## 41 13.690472
## 42 13.690472
## 43 14.966642
## 44 15.129262
## 45 15.230624
## 46 15.788086
## 47 16.125457
## 48 16.239778
## 49 16.382188
## 50 16.408663
## 51 16.509685
## 52 17.010511
## 53 17.087517
## 54 17.158761
## 55 17.578887
## 56 17.773351
## 57 17.793552
## 58 17.829544
## 59 18.416453
## 60 18.513537
## 61 18.839479
## 62 19.172878
## 63 19.432886
## 64 19.448805
## 65 19.491447
## 66 19.954956
## 67 19.993316
## 68 20.103933
## 69 20.223613
## 70 20.420695
## 71 20.535018
## 72 20.564229
## 73 21.414594
## 74 21.525752
## 75 22.000521
## 76 22.202552
## 77 22.747356
## 78 23.030744
## 79 23.256162
## 80 23.345895
## 81 23.393049
## 82 23.465245
## 83 23.617812
## 84 23.701976
## 85 23.749365
## 86 24.591309
## 87 24.713433
## 88 24.802430
## 89 25.351527
## 90 25.367641
## 91 25.480101
## 92 25.907856
## 93 26.526359
## 94 26.675842
## 95 26.875070
## 96 26.914609
## 97 27.238327
## 98 27.399212
## 99 27.516720
## 100 27.737658
## 101 27.854473
## 102 27.894067
## 103 27.953385
## 104 28.435114
## 105 28.480727
## 106 28.545203
## 107 28.640881
## 108 28.725743
## 109 28.984935
## 110 29.237785
## 111 29.667485
## 112 29.740401
##
## $miyazaki
## id name latitude longitude distance
## 1 JA000047830 MIYAZAKI 31.933 131.417 8.699733
## 2 JA000047829 MIYAKONOJO 31.733 131.083 29.908209
##
## $murcia
## id name latitude longitude distance
## 1 SPE00120323 MURCIA 38.0028 -1.1692 5.001690
## 2 SPE00120332 MURCIA/ALCANTARILLA 37.9578 -1.2294 9.902609
##
## $pamplona
## id name latitude longitude distance
## 1 SPE00120350 PAMPLONA (OBSERVATORIO) 42.8175 -1.6364 1.387848
## 2 SPE00120359 PAMPLONA 42.7767 -1.6500 3.702791
##
## $`pas-de-calais`
## [1] id name latitude longitude distance
## <0 rows> (or 0-length row.names)
##
## $pittsburgh
## id name latitude longitude distance
## 1 US1PAAL0014 PA PITTSBURGH 1.6 SW 40.4226 -79.9974 1.687108
## 2 USW00014861 PA PITTSBURGH WSO CITY 40.4500 -80.0000 2.794735
## 3 USC00366986 PA PIT CARNEGIE SCI CTR 40.4450 -80.0186 3.667959
## 4 US1PAAL0017 PA WHITEHALL 1.0 SW 40.3475 -80.0022 9.364279
## 5 USW00014762 PA PITTSBURGH ALLEGHENY CO AP 40.3547 -79.9217 9.720301
## 6 US1PAAL0011 PA WEST MIFFLIN 1.3 SW 40.3466 -79.9283 10.255413
## 7 US1PAAL0031 PA SCOTT TOWNSHIP 1.3 NW 40.3978 -80.0967 10.508788
## 8 USC00360861 PA BRADDOCK LOCK 2 40.3917 -79.8594 11.063215
## 9 US1PAAL0009 PA PATHFINDER 40.3416 -80.0485 11.414110
## 10 USC00361773 PA CORAOPOLIS NEVILLE IS 40.5000 -80.0833 11.702719
## 11 USC00362574 PA EMSWORTH L/D OHIO RVR 40.5019 -80.0833 11.844197
## 12 US1PAAL0016 PA GLENSHAW 1.3 NW 40.5488 -79.9800 13.209957
## 13 USC00365573 PA MCKEESPORT 40.3392 -79.8603 14.308275
## 14 US1PAAL0008 PA UPPER ST. CLAIR 1.7 WNW 40.3412 -80.1026 14.329100
## 15 USC00361033 PA BRUCETON 1 S 40.3000 -79.9833 14.458044
## 16 US1PAAL0020 PA ALLISON PARK 0.7 W 40.5610 -79.9708 14.587294
## 17 US1PAAL0023 PA SOUTH PARK TOWNSHIP 0.2 NW 40.2989 -79.9970 14.648635
## 18 US1PAAL0003 PA SOUTH FAYETTE 2 SE 40.3381 -80.1159 15.392161
## 19 US1PAAL0001 PA BRIDGEVILLE 1.4 SW 40.3417 -80.1229 15.584945
## 20 US1PAAL0004 PA PENN HILLS 1.5 E 40.4759 -79.7982 16.207171
## 21 US1PAAL0039 PA ROBINSON TOWNSHIP 2.2 WNW 40.4727 -80.1656 16.406517
## 22 US1PAAL0041 PA OAKMONT 0.8 N 40.5313 -79.8345 16.682849
## 23 USC00360022 PA ACMETONIA LOCK 3 40.5361 -79.8153 18.254228
## 24 US1PAAL0006 PA MCDONALD 2.5 ENE 40.3822 -80.1871 18.323293
## 25 US1PAWS0005 PA MCMURRAY 0.2 NE 40.2831 -80.0857 18.628831
## 26 US1PAWS0008 PA VENETIA 0.7 WNW 40.2522 -80.0539 20.738838
## 27 USW00094823 PA PITTSBURGH INTL AP 40.4847 -80.2144 20.743637
## 28 US1PAAL0033 PA CARNOT-MOON 0.7 ENE 40.5224 -80.2014 21.360098
## 29 US1PAAL0030 PA CARNOT-MOON 0.9 S 40.5061 -80.2119 21.364459
## 30 USC00366111 PA MURRYSVILLE 2 SW 40.4119 -79.7244 21.730660
## 31 US1PAWT0001 PA NORTH IRWIN 2.5 WSW 40.3243 -79.7556 22.348628
## 32 USC00365918 PA MOON TOWNSHIP 40.5319 -80.2172 23.040372
## 33 USC00363343 PA GLENWILLARD DASHIELDS 40.5514 -80.2167 24.143027
## 34 USC00360355 PA BAKERSTOWN 3 WNW 40.6500 -79.9833 24.464473
## 35 US1PAWT0010 PA MURRYSVILLE 1.5 WSW 40.4317 -79.6813 25.282776
## 36 US1PAAL0012 PA SOUTH HEIGHTS 1.5 S 40.5533 -80.2379 25.760534
## 37 US1PAWS0009 PA CANONSBURG 0.3 SSW 40.2597 -80.1900 25.987112
## 38 US1PAWT0014 PA LOWER BURRELL 1.2 WNW 40.5918 -79.7333 27.543709
##
## $portugal
## [1] id name latitude longitude distance
## <0 rows> (or 0-length row.names)
##
## $quebec
## id name latitude longitude distance
## 1 CA007015417 QC NEUFCHATEL 46.8500 -71.3667 2.030466
## 2 CA007014329 QC LORETTEVILLE 46.8667 -71.3667 2.751325
## 3 CA007014298 QC LES SAULES 46.8167 -71.3167 4.105150
## 4 CA007012232 QC DUBERGER 46.8167 -71.3000 4.792654
## 5 CA007011309 QC CHARLESBOURG PARC ORLEAN 46.8667 -71.2667 5.874619
## 6 CA007011308 QC CHARLESBOURG JAR ZOO 46.9000 -71.3000 6.336821
## 7 CA007016294 QC QUEBEC/JEAN LESAGE INTL A 46.8000 -71.3833 6.462488
## 8 CA00701S001 QC QUEBEC/JEAN LESAGE INTL 46.8000 -71.3833 6.462488
## 9 CA007017BFN QC STE FOY (PIE XII) 46.7833 -71.3167 7.625681
## 10 CA007016281 QC QUEBEC 2 46.8000 -71.2667 7.874784
## 11 CA00701Q004 QC STE-FOY (U. LAVAL) 46.7833 -71.2833 8.580380
## 12 CA007012040 QC DOMAINE-DE-MAIZERETS 46.8333 -71.2167 9.560181
## 13 CA007010565 QC BEAUPORT 46.8333 -71.2000 10.808994
## 14 CA007010566 QC BEAUPORT 46.8833 -71.2000 11.269037
## 15 CA007017B65 QC STE FOY MATAPEDIA 46.7500 -71.2833 11.927703
## 16 CA007017265 QC STE FOY 46.7500 -71.2667 12.440799
## 17 CA007027700 QC ST ROMUALD 46.7667 -71.2167 13.185308
## 18 CA007018762 QC VILLENEUVE 46.8667 -71.1667 13.307164
## 19 CA007018572 QC VALCARTIER 46.9000 -71.5000 13.372471
## 20 CA007018574 QC VALCARTIER A 46.9000 -71.5000 13.372471
## 21 CA00701A9E0 QC COURVILLE DE POISSY 46.8833 -71.1667 13.685368
## 22 CA00701LF83 QC LA COURVILLOISE 46.9000 -71.1500 15.475466
## 23 CA007018577 QC VALCARTIER FES 46.9500 -71.5000 16.474749
## 24 CA007027391 QC ST JEAN CHRYSOSTOME 46.7167 -71.2167 17.545358
## 25 CA007016900 QC ST AUGUSTIN 46.7333 -71.5000 17.797745
## 26 CA007024254 QC LAUZON 46.8167 -71.1000 18.628731
## 27 CA007016932 QC STE CATHERINE 46.8500 -71.6167 21.042305
## 28 CA007047442 QC ST LAURENT ILE D'ORLEANS 46.8667 -71.0500 22.128358
## 29 CA007012240 QC DUCHESNAY 46.8667 -71.6500 23.644047
## 30 CA007020567 QC BEAUSEJOUR 46.6667 -71.1667 24.283856
## 31 CA007041330 QC CHATEAU RICHER 46.9667 -71.0333 26.668362
##
## $`rapid city`
## id name latitude longitude distance
## 1 US1SDPN0044 SD RAPID CITY 2.0 SSE 44.0487 -103.2173 1.274894
## 2 USC00396948 SD RAPID CITY WFO 44.0728 -103.2108 1.601898
## 3 US1SDPN0036 SD RAPID CITY 2.9 SE 44.0414 -103.1994 2.643470
## 4 US1SDPN0001 SD RAPID CITY 1.7 NW 44.0850 -103.2339 2.993462
## 5 US1SDPN0053 SD RAPID CITY 2.6 SW 44.0519 -103.2739 4.400391
## 6 US1SDPN0049 SD RAPID CITY 3.8 S 44.0208 -103.2418 4.694241
## 7 US1SDPN0030 SD RAPID CITY 3.3 SSW 44.0345 -103.2677 4.751190
## 8 US1SDPN0033 SD RAPID CITY 2.5 WSW 44.0644 -103.2805 4.858829
## 9 US1SDPN0043 SD RAPID CITY 3.9 S 44.0183 -103.2395 4.891807
## 10 US1SDPN0005 SD RAPID CITY 4.3 ESE 44.0472 -103.1555 5.347390
## 11 US1SDPN0027 SD RAPID CITY 2.4 WNW 44.0849 -103.2804 5.563235
## 12 US1SDPN0006 SD RAPID CITY 4.5 E 44.0661 -103.1436 6.142072
## 13 US1SDPN0057 SD RAPID CITY 4.7 E 44.0624 -103.1398 6.413886
## 14 US1SDPN0058 SD RAPID CITY 4.6 E 44.0722 -103.1402 6.518563
## 15 US1SDPN0038 SD RAPID CITY 3.5 NE 44.1134 -103.1860 6.529314
## 16 US1SDPN0002 SD RAPID CITY 3.4 WNW 44.0886 -103.2997 7.117009
## 17 US1SDPN0017 SD RAPID CITY 3.5 WNW 44.0860 -103.3015 7.123918
## 18 USC00396947 SD RAPID CITY 4NW 44.1150 -103.2828 7.909484
## 19 US1SDPN0047 SD RAPID CITY 6.3 SE 44.0061 -103.1506 8.167081
## 20 US1SDPN0004 SD RAPID CITY 5.4 SW 44.0135 -103.3008 8.273610
## 21 US1SDPN0031 SD RAPID CITY 5.8 SW 44.0057 -103.2975 8.651065
## 22 US1SDPN0016 SD RAPID CITY 6.1 SW 44.0069 -103.3094 9.270343
## 23 US1SDPN0032 SD RAPID CITY 6.3 SW 44.0028 -103.3105 9.633226
## 24 US1SDPN0029 SD RAPID CITY 6.4 WNW 44.1009 -103.3574 11.880241
## 25 US1SDPN0040 SD RAPID CITY 6.9 W 44.0866 -103.3701 12.350597
## 26 US1SDMD0019 SD BLACKHAWK 0.1 WNW 44.1520 -103.3165 12.806932
## 27 USW00024090 SD RAPID CITY RGNL AP 44.0433 -103.0536 13.427258
## 28 USW00024006 SD ELLSWORTH AFB 44.1500 -103.1000 13.854769
## 29 US1SDPN0034 SD RAPID CITY 8.1 WNW 44.1294 -103.3783 14.810927
## 30 US1SDPN0018 SD RAPID CITY 9.8 SW 43.9660 -103.3603 15.334040
## 31 US1SDMD0004 SD BLACKHAWK 2.0 NNW 44.1780 -103.3326 15.904487
## 32 US1SDPN0050 SD BOX ELDER 1.6 NE 44.1387 -103.0532 15.937019
## 33 US1SDMD0018 SD BLACKHAWK 2.3 NNW 44.1825 -103.3347 16.412472
## 34 US1SDPN0056 SD RAPID CITY 9.6 WNW 44.1274 -103.4116 17.038100
## 35 USC00394343 SD JOHNSON SIDING 44.0839 -103.4342 17.317536
## 36 USR0000SBAK SD BAKER PARK SOUTH DAKOTA 43.9792 -103.4250 18.692682
## 37 US1SDPN0015 SD HERMOSA 4.4 NNE 43.8980 -103.1560 18.727341
## 38 US1SDMD0032 SD PIEDMONT 4.6 E 44.2307 -103.2966 19.940748
## 39 USC00396427 SD PACTOLA DAM 44.0622 -103.4819 20.928415
## 40 US1SDPN0022 SD BOX ELDER 6.2 ESE 44.1000 -102.9500 22.021177
## 41 USC00394556 SD KEYSTONE 43.9039 -103.4100 23.073539
## 42 US1SDCS0018 SD HERMOSA 4.9 W 43.8494 -103.2883 24.047399
## 43 US1SDMD0001 SD BOX ELDER 8.0 NNE 44.2318 -103.0345 24.166211
## 44 US1SDCS0017 SD HERMOSA 0.3 ENE 43.8410 -103.1854 24.508709
## 45 US1SDMD0025 SD PIEDMONT 1.0 NW 44.2405 -103.4041 24.871196
## 46 USC00392888 SD FARMINGDALE 4 N 44.0333 -102.9000 25.747413
## 47 USR0000SNEM SD NEMO SOUTH DAKOTA 44.1917 -103.5097 27.370234
## 48 US1SDPN0013 SD SILVER CITY 44.0848 -103.5634 27.572203
## 49 USC00395870 SD MT RUSHMORE NATL MEM 43.8769 -103.4578 27.869317
## 50 USR0000SMRU SD MT. RUSHMORE SOUTH DAKOTA 43.8750 -103.4583 28.051427
## 51 USC00393775 SD HERMOSA 3 SSW 43.8069 -103.2131 28.148859
## 52 US1SDPN0055 SD HILL CITY 1.0 ENE 43.9382 -103.5542 29.967107
##
## $sarpsborg
## id name latitude longitude distance
## 1 NOE00109849 SARPSBORG 59.2856 11.1144 2.050694
## 2 NOE00109804 BATEROD 59.3078 11.1314 4.251261
## 3 NOE00134298 FLOTER 59.4964 11.0131 24.358920
## 4 NOE00100575 HALDEN 59.1225 11.3883 24.795447
## 5 NOE00109786 HVALER 59.0358 11.0517 27.201683
## 6 NOE00109876 MOSS BRANNSTASJON 59.4428 10.6842 28.822789
## 7 NOE00109867 MOSS 59.4339 10.6667 29.008867
##
## $`stoke-on-trent`
## [1] id name latitude longitude distance
## <0 rows> (or 0-length row.names)
##
## $sydney
## id name latitude longitude
## 1 ASN00067072 FAIRFIELD HEIGHTS POST OFFICE -33.8667 150.9333
## 2 ASN00067019 PROSPECT RESERVOIR -33.8193 150.9127
## 3 ASN00067017 GREYSTANES (BATHURST STREET) -33.8136 150.9392
## 4 ASN00067070 MERRYLANDS (WELSFORD STREET) -33.8269 150.9767
## 5 ASN00067008 GUILDFORD -33.8667 150.9833
## 6 ASN00067091 CABRAMATTA -33.9000 150.9167
## 7 ASN00067006 FAIRFIELD MWSDB -33.9000 150.9500
## 8 ASN00067032 WESTMEAD AUSTRAL AVENUE -33.8144 150.9833
## 9 ASN00067114 ABBOTSBURY (FAIRFIELD CITY FAR -33.8667 150.8611
## 10 ASN00066169 VILLAWOOD ARCHIVES -33.8333 151.0000
## 11 ASN00067119 HORSLEY PARK EQUESTRIAN CENTRE -33.8511 150.8567
## 12 ASN00067110 SEVEN HILLS (RADIO FM 103.2) -33.7858 150.9236
## 13 ASN00067013 LIVERPOOL -33.9167 150.9333
## 14 ASN00066121 CHESTER HILL -33.8833 151.0000
## 15 ASN00066025 WARWICK FARM (LIVERPOOL TREATM -33.9194 150.9383
## 16 ASN00066085 GRANVILLE RSL BOWLING CLUB -33.8361 151.0128
## 17 ASN00067035 LIVERPOOL(WHITLAM CENTRE) -33.9272 150.9128
## 18 ASN00067026 SEVEN HILLS (COLLINS ST) -33.7704 150.9318
## 19 ASN00067020 LIVERPOOL (MICHAEL WENDEN CENT -33.9214 150.8861
## 20 ASN00067064 CECIL PARK ANDERSONS RES.FARM -33.8667 150.8333
## 21 ASN00066137 BANKSTOWN AIRPORT AWS -33.9181 150.9864
## 22 ASN00067080 WINSTON HILLS LANHAMS ROAD -33.7774 150.9779
## 23 ASN00067000 EASTERN CREEK (WONDERLAND) -33.8022 150.8479
## 24 ASN00067069 GREENVALLEY (MILLER) -33.9167 150.8667
## 25 ASN00066055 LIDCOMBE (CARNARVON GOLF CLUB) -33.8667 151.0333
## 26 ASN00066134 GRANVILLE SHELL REFINERY -33.8322 151.0340
## 27 ASN00067059 BLACKTOWN -33.7694 150.8856
## 28 ASN00066168 MILPERRA BRIDGE (GEORGES RIVER -33.9289 150.9831
## 29 ASN00067042 KINGS LANGLEY (SOLANDER RD) -33.7610 150.9498
## 30 ASN00067111 NORTH PARRAMATTA (BURNSIDE HOM -33.7931 151.0167
## 31 ASN00066174 DUNDAS -33.8167 151.0333
## 32 ASN00067109 BAULKHAM HILLS EUCALYPTUS CT -33.7678 150.9814
## 33 ASN00066124 PARRAMATTA NORTH (MASONS DRIVE -33.7917 151.0181
## 34 ASN00067016 MINCHINBURY -33.8000 150.8333
## 35 ASN00066050 POTTS HILL RESERVOIR -33.8933 151.0346
## 36 ASN00066003 BANKSTOWN (CONDELL PARK) -33.9167 151.0167
## 37 ASN00067097 PRESTONS BERNERA ROAD -33.9333 150.8667
## 38 ASN00066154 HOLDSWORTHY AIR CAVALRY -33.9500 150.9500
## 39 ASN00066171 MOOREBARK N.B.GOLF CLUB -33.9500 150.9500
## 40 ASN00067120 HOXTON PARK (RANIERI PLACE) -33.9319 150.8553
## 41 ASN00066164 ROOKWOOD (HAWTHORNE AVE) -33.8771 151.0577
## 42 ASN00067112 NORTH ROCKS (MUIRFIELD GOLF CL -33.7672 151.0186
## 43 ASN00066195 SYDNEY OLYMPIC PARK (SYDNEY OL -33.8521 151.0646
## 44 ASN00066070 STRATHFIELD GOLF CLUB -33.8805 151.0631
## 45 ASN00066135 SILVERWATER (RANAD NEWINGTON) -33.8333 151.0667
## 46 ASN00066054 REVESBY (PATEN STREET) -33.9474 151.0065
## 47 ASN00067009 GLENFIELD (MACQUARIE) -33.9667 150.9000
## 48 ASN00067076 QUAKERS HILL TREATMENT WORKS -33.7366 150.8758
## 49 ASN00067092 QUAKERS HILL DOUGLAS RD. -33.7333 150.8833
## 50 ASN00067036 AUSTRAL EIGHTH AVE -33.9333 150.8167
## 51 ASN00066185 CARLINGFORD (BARELLAN AV) -33.7801 151.0587
## 52 ASN00066082 CONCORD WEST PLASTER MILLS -33.8333 151.0833
## 53 ASN00066191 GLENFIELD (HARROW ROAD) -33.9770 150.9042
## 54 ASN00067117 HOLSWORTHY CONTROL RANGE -33.9795 150.9254
## 55 ASN00067118 OAKHURST (LAWTON PLACE) -33.7431 150.8356
## 56 ASN00067102 ST CLAIR (JUBA CLOSE) -33.8044 150.7778
## 57 ASN00067100 CASTLE HILL (KATHLEEN AVE) -33.7260 150.9944
## 58 ASN00067083 MOUNT DRUITT FRANCIS STREET -33.7667 150.8000
## 59 ASN00067089 WEST PENNANT HILLS (CUMBERLAND -33.7459 151.0402
## 60 ASN00067003 COLYTON (CARPENTER ST) -33.7770 150.7877
## 61 ASN00067098 WEST PENNANT HILLS (ORATAVA A -33.7487 151.0449
## 62 ASN00066013 CONCORD GOLF CLUB -33.8523 151.0985
## 63 ASN00066087 EASTWOOD BOWLING CLUB -33.7933 151.0862
## 64 ASN00066064 CONCORD WALKER HOSPITAL -33.8333 151.1000
## 65 ASN00066076 WILEY PARK (ROSELANDS) -33.9367 151.0700
## 66 ASN00066057 RYDE PUMPING STATION -33.8167 151.1000
## 67 ASN00067061 ROSSMORE (SOUTH CREEK) -33.9353 150.7819
## 68 ASN00066048 CONCORD (BRAYS RD) -33.8483 151.1105
## 69 ASN00066020 EPPING CHESTER STREET -33.7687 151.0852
## 70 ASN00066071 GLADESVILLE CHAMPION RD -33.8381 151.1161
## 71 ASN00066017 FIVE DOCK (BARNWELL PARK GOLF -33.8681 151.1190
## 72 ASN00067024 ST MARYS BOWLING CLUB -33.7667 150.7667
## 73 ASN00067037 SCHOFIELDS BOUNDARY RD -33.6947 150.8868
## 74 ASN00066194 CANTERBURY RACECOURSE AWS -33.9057 151.1134
## 75 ASN00066144 PEAKHURST FOREST ROAD -33.9667 151.0667
## 76 ASN00066148 PEAKHURST GOLF CLUB -33.9700 151.0638
## 77 ASN00066034 ABBOTSFORD (BLACKWALL POINT RD -33.8507 151.1295
## 78 ASN00067116 WILLMOT (RESOLUTION AVE) -33.7231 150.7997
## 79 ASN00066156 MACQUARIE PARK (WILLANDRA VILL -33.7791 151.1121
## 80 ASN00067060 LONG POINT -34.0167 150.9000
## 81 ASN00067068 BADGERYS CREEK MCMASTERS F.STN -33.8683 150.7278
## 82 ASN00066047 PENNANT HILLS (YARRARA ROAD) -33.7324 151.0767
## 83 ASN00067107 VARROVILLE (ST JAMES ROAD) -33.9928 150.8178
## 84 ASN00066190 INGLEBURN (SACKVILLE STREET) -34.0117 150.8647
## 85 ASN00066049 PENSHURST -33.9667 151.0833
## 86 ASN00066000 ASHFIELD BOWLING CLUB -33.8850 151.1344
## 87 ASN00067108 BADGERYS CREEK AWS -33.8969 150.7281
## 88 ASN00066181 OATLEY (WORONORA PARADE) -33.9766 151.0766
## 89 ASN00066004 BEXLEY BOWLING CLUB -33.9430 151.1098
## 90 ASN00066018 EARLWOOD BOWLING CLUB -33.9333 151.1167
## 91 ASN00066081 NORTH RYDE STROUD STREET -33.8000 151.1333
## 92 ASN00066193 MARSFIELD (MACQUARIE UNIVERSIT -33.7654 151.1176
## 93 ASN00067025 ST MARYS MWSDB -33.7333 150.7667
## 94 ASN00067086 DURAL (OLD NORTHERN ROAD) -33.6867 151.0250
## 95 ASN00067071 THORNLEIGH BRIDGEVIEW CRESCENT -33.7167 151.0833
## 96 ASN00066036 MARRICKVILLE GOLF CLUB -33.9186 151.1402
## 97 ASN00066092 DURAL -33.6833 151.0333
## 98 ASN00066131 RIVERVIEW OBSERVATORY -33.8258 151.1556
## 99 ASN00067104 BOX HILL (HYNDS ROAD) -33.6617 150.9000
## 100 ASN00067101 BOX HILL JUNCTION ROAD -33.6649 150.8780
## 101 ASN00066189 WEST PYMBLE (WYUNA ROAD) -33.7693 151.1380
## 102 ASN00066028 HORNSBY (PRETORIA PARADE) -33.7083 151.0839
## 103 ASN00067084 ORCHARD HILLS TREATMENT WORKS -33.8020 150.7069
## 104 ASN00068043 MINTO SURREY STREET -34.0283 150.8433
## 105 ASN00066204 OYSTER BAY (GREEN POINT ROAD) -34.0009 151.0738
## 106 ASN00066032 LINDFIELD WEST -33.7822 151.1486
## 107 ASN00066069 HURSTVILLE GROVE (WAITARA PARA -33.9833 151.1000
## 108 ASN00066074 ROCKDALE BOWLING CLUB -33.9500 151.1333
## 109 ASN00066158 TURRAMURRA (KISSING POINT ROAD -33.7366 151.1271
## 110 ASN00066063 WAHROONGA RESERVOIR -33.7206 151.1128
## 111 ASN00066120 GORDON GOLF CLUB -33.7617 151.1462
## 112 ASN00068220 MINTO (ALDERNEY STREET) -34.0411 150.8458
## 113 ASN00066023 LUCAS HEIGHTS AWS -34.0514 150.9800
## 114 ASN00066078 LUCAS HEIGHTS (ANSTO) -34.0517 150.9800
## 115 ASN00066027 HORNSBY MWSDB -33.7000 151.1000
## 116 ASN00066159 HORNSBY (MOUNT WILGA) -33.6939 151.0925
## 117 ASN00067015 BRINGELLY (MARYLAND) -33.9696 150.7250
## 118 ASN00068160 CAMPBELLTOWN (KENTLYN (GEORGES -34.0542 150.8772
## 119 ASN00067106 BERKSHIRE PARK FIRST RD -33.6708 150.7972
## 120 ASN00068250 CAMDEN VALLEY GOLF RESORT -34.0128 150.7675
## 121 ASN00066060 SUTHERLAND MWSDB -34.0333 151.0667
## 122 ASN00066157 PYMBLE (CANISIUS COLLEGE) -33.7371 151.1521
## 123 ASN00066058 SANS SOUCI (PUBLIC SCHOOL) -33.9942 151.1292
## 124 ASN00066205 WAHROONGA (BOUNDARY ROAD) -33.7073 151.1315
## 125 ASN00066056 ROSEVILLE BOWLING CLUB -33.7833 151.1833
## 126 ASN00067022 GALSTON (ROWLAND VILLAGE) -33.6550 151.0553
## 127 ASN00066090 ENGADINE (CAMBRAI AVE) -34.0608 151.0125
## 128 ASN00066075 WAVERTON BOWLING CLUB -33.8411 151.1967
## 129 ASN00066010 CHATSWOOD COUNCIL DEPOT -33.8014 151.1917
## 130 ASN00068231 RUSE (DENISON STREET) -34.0630 150.8489
## 131 ASN00066114 NORTH TURRAMURRA (DRYDEN RD) -33.7179 151.1470
## 132 ASN00066037 SYDNEY AIRPORT AMO -33.9465 151.1731
## 133 ASN00066033 ALEXANDRIA (HENDERSON ROAD) -33.8992 151.1933
## 134 ASN00066061 SYDNEY NTH BOWLING CLUB -33.8333 151.2000
## 135 ASN00066067 WOLLSTONECRAFT -33.8333 151.2000
## 136 ASN00066062 SYDNEY (OBSERVATORY HILL) -33.8607 151.2050
## 137 ASN00066011 CHATSWOOD BOWLING CLUB -33.8000 151.2000
## 138 ASN00066012 CHATSWOOD WATER SUPPLY -33.8000 151.2000
## 139 ASN00067018 PENRITH LADBURY AVENUE -33.7542 150.6783
## 140 ASN00067073 MARALYA BOUNDARY ROAD -33.6200 150.8967
## 141 ASN00067115 GLENMORE PARK (CARTWRIGHT CL) -33.7826 150.6619
## 142 ASN00066021 ALEXANDRIA (ERSKINEVILLE) -33.9167 151.2000
## 143 ASN00066040 MIRANDA (BLACKWOOD ST) -34.0405 151.0982
## 144 ASN00068015 CAMPBELLTOWN 2 MWSDB -34.0667 150.8167
## 145 ASN00066117 TURRAMURRA NORTH -33.7167 151.1667
## 146 ASN00066006 SYDNEY BOTANIC GARDENS -33.8662 151.2160
## 147 ASN00066080 CASTLE COVE (ROSEBRIDGE AVE) -33.7809 151.2044
## 148 ASN00066001 AUDLEY NATIONAL PARK BOTTOM ST -34.0667 151.0500
## 149 ASN00066176 AUDLEY (ROYAL NATIONAL PARK) -34.0658 151.0567
## 150 ASN00066139 PADDINGTON -33.8833 151.2167
## 151 ASN00067029 WALLACIA POST OFFICE -33.8637 150.6410
## 152 ASN00066167 NORTHBRIDGE BOWLING CLUB -33.8057 151.2145
## 153 ASN00066130 NORTHBRIDGE (SAILORS BAY) -33.8167 151.2167
## 154 ASN00067004 EMU PLAINS -33.7500 150.6667
## 155 ASN00068037 KENNY HILL -34.0500 150.7667
## 156 ASN00066166 CREMORNE GRASMERE ROAD -33.8283 151.2217
## 157 ASN00067087 GLENORIE (GATELEIGH PARK) -33.6167 151.0167
## 158 ASN00067067 EMU PLAINS -33.7600 150.6567
## 159 ASN00066206 ST IVES (RICHMOND AVENUE) -33.7096 151.1730
## 160 ASN00067113 PENRITH LAKES AWS -33.7195 150.6783
## 161 ASN00068257 CAMPBELLTOWN (MOUNT ANNAN) -34.0615 150.7735
## 162 ASN00068230 CAMPBELLTOWN U.W.S. -34.0697 150.7878
## 163 ASN00068081 CAMPBELLTOWN SWIMMING CENTRE -34.0833 150.8167
## 164 ASN00066007 BOTANY NO.1 DAM -33.9333 151.2167
## 165 ASN00066073 RANDWICK RACECOURSE -33.9105 151.2276
## 166 ASN00068254 MOUNT ANNAN BOTANIC GARDEN -34.0673 150.7678
## 167 ASN00066009 CENTENNIAL PARK ROUND HOUSE -33.8975 151.2328
## 168 ASN00067063 COBBITTY (CUTHILL) -33.9833 150.6667
## 169 ASN00066160 CENTENNIAL PARK -33.8959 151.2341
## 170 ASN00067031 WINDSOR BOWLING CLUB -33.6100 150.8151
## 171 ASN00066042 MOSMAN (BAPAUME ROAD) -33.8194 151.2428
## 172 ASN00066188 BELROSE (EVELYN PLACE) -33.7402 151.2173
## 173 ASN00068227 AMBARVALE CLENNAM AVE -34.0867 150.7917
## 174 ASN00066145 SEAFORTH CASTLE CIRCUIT -33.7894 151.2392
## 175 ASN00068207 COBBITY (ROSENEATH) -34.0167 150.6833
## 176 ASN00066184 MOSMAN COUNCIL -33.8340 151.2484
## 177 ASN00066052 RANDWICK BOWLING CLUB -33.9096 151.2419
## 178 ASN00066086 CRONULLA STP -34.0313 151.1642
## 179 ASN00066041 MOSMAN WATER SUPPLY -33.8333 151.2500
## 180 ASN00066136 CARINGBAH (LILLI PILLI) -34.0667 151.1167
## 181 ASN00068070 WORONORA DAM -34.1167 150.9333
## 182 ASN00068011 CAMDEN BOWLING CLUB -34.0500 150.7167
## 183 ASN00067010 GLENORIE (OLD NORTHERN RD) -33.5908 151.0094
## distance
## 1 1.881790
## 2 3.769152
## 3 4.135739
## 4 5.020100
## 5 5.260294
## 6 5.693717
## 7 5.858326
## 8 6.317220
## 9 6.627566
## 10 6.726345
## 11 6.770114
## 12 7.163157
## 13 7.422955
## 14 7.448599
## 15 7.754869
## 16 7.801609
## 17 8.729832
## 18 8.852678
## 19 8.913714
## 20 9.120153
## 21 9.189477
## 22 9.206123
## 23 9.260935
## 24 9.442011
## 25 9.717611
## 26 9.806921
## 27 9.856503
## 28 10.049571
## 29 10.064021
## 30 10.206744
## 31 10.234628
## 32 10.300292
## 33 10.404864
## 34 10.521499
## 35 10.790772
## 36 10.911531
## 37 10.951350
## 38 11.271660
## 39 11.271660
## 40 11.422627
## 41 12.169844
## 42 12.319787
## 43 12.431978
## 44 12.748603
## 45 12.760934
## 46 12.928587
## 47 13.268493
## 48 13.567795
## 49 13.675242
## 50 13.970001
## 51 14.205035
## 52 14.279472
## 53 14.321038
## 54 14.405998
## 55 14.744007
## 56 14.945410
## 57 15.017779
## 58 15.167677
## 59 15.416884
## 60 15.450666
## 61 15.478987
## 62 15.562401
## 63 15.746686
## 64 15.809996
## 65 16.122048
## 66 16.132769
## 67 16.638119
## 68 16.669913
## 69 16.950934
## 70 17.237878
## 71 17.567447
## 72 17.704003
## 73 17.724215
## 74 18.028240
## 75 18.097853
## 76 18.179759
## 77 18.423361
## 78 18.550317
## 79 18.579019
## 80 18.741684
## 81 18.781169
## 82 18.835558
## 83 18.955452
## 84 18.962689
## 85 19.197135
## 86 19.269018
## 87 19.355573
## 88 19.523783
## 89 19.553323
## 90 19.564367
## 91 19.585383
## 92 19.721134
## 93 19.902615
## 94 20.170027
## 95 20.504349
## 96 20.849104
## 97 20.851122
## 98 21.009524
## 99 21.120894
## 100 21.136126
## 101 21.209116
## 102 21.226965
## 103 21.288391
## 104 21.378555
## 105 21.391107
## 106 21.556418
## 107 21.581812
## 108 21.810557
## 109 22.152621
## 110 22.190861
## 111 22.258367
## 112 22.624322
## 113 22.864610
## 114 22.897282
## 115 22.914815
## 116 22.954030
## 117 23.124628
## 118 23.222412
## 119 23.404366
## 120 23.504569
## 121 23.967617
## 122 24.058869
## 123 24.391064
## 124 24.466552
## 125 24.547893
## 126 24.583503
## 127 24.644041
## 128 24.650159
## 129 24.770808
## 130 24.837610
## 131 24.858762
## 132 24.870760
## 133 24.916043
## 134 25.005231
## 135 25.005231
## 136 25.421751
## 137 25.553205
## 138 25.553205
## 139 25.580355
## 140 25.759544
## 141 25.877100
## 142 26.004107
## 143 26.257057
## 144 26.264221
## 145 26.424281
## 146 26.470162
## 147 26.489163
## 148 26.516139
## 149 26.689966
## 150 26.728506
## 151 26.729649
## 152 26.737272
## 153 26.738727
## 154 26.749858
## 155 26.859908
## 156 27.048941
## 157 27.152433
## 158 27.162530
## 159 27.351861
## 160 27.416523
## 161 27.594122
## 162 27.727260
## 163 27.966933
## 164 28.037230
## 165 28.284461
## 166 28.418732
## 167 28.449544
## 168 28.460442
## 169 28.535385
## 170 28.724326
## 171 29.091049
## 172 29.221247
## 173 29.247143
## 174 29.347935
## 175 29.352997
## 176 29.459874
## 177 29.545881
## 178 29.549535
## 179 29.612274
## 180 29.616192
## 181 29.657248
## 182 29.692767
## 183 29.742533
Not all the locations have stations nearby. Therefore, I will omit them from the weather data evaluation using the following code.
has_stations <- sapply(stations, function(x) nrow(x) > 0)
outbreak_loc_true <- outbreak_loc %>%
arrange(id) %>%
filter(has_stations)
outbreak_loc_true$stations <- NULL
outbreak_loc_true
## id file_id latitude longitude year_min date_min
## 1 bovenkarspel bovenkarspel 52.70 5.24 1989 1989-01-01
## 2 bronx bronx 40.82 -73.92 2005 2005-01-01
## 3 columbus columbus 39.98 -82.99 2003 2003-01-01
## 4 genesee1 genesee1 43.09 -83.63 2004 2004-01-01
## 5 genesee2 genesee2 43.09 -83.63 2005 2005-01-01
## 6 london london 51.52 -0.10 1979 1979-01-01
## 7 melbourne melbourne -37.86 145.07 1990 1990-01-01
## 8 miyazaki miyazaki 31.89 131.34 1992 1992-01-01
## 9 murcia murcia 37.98 -1.12 1991 1991-01-01
## 10 pamplona pamplona 42.81 -1.65 1996 1996-01-01
## 11 pittsburgh pittsburgh 40.43 -79.98 2002 2002-01-01
## 12 quebec quebec 46.85 -71.34 2002 2002-01-01
## 13 rapid city rapid_city 44.06 -103.22 1995 1995-01-01
## 14 sarpsborg sarpsborg 59.28 11.08 1995 1995-01-01
## 15 sydney sydney -33.85 150.93 2006 2006-01-01
## year_max date_max onset before_onset
## 1 1999 1999-12-31 1999-02-25 1999-02-11
## 2 2015 2015-12-31 2015-07-12 2015-06-28
## 3 2013 2013-12-31 2013-07-09 2013-06-25
## 4 2014 2014-12-31 2014-06-06 2014-05-23
## 5 2015 2015-12-31 2015-05-04 2015-04-20
## 6 1989 1989-12-31 1989-01-01 1988-12-18
## 7 2000 2000-12-31 2000-04-17 2000-04-03
## 8 2002 2002-12-31 2002-07-18 2002-07-04
## 9 2001 2001-12-31 2001-06-26 2001-06-12
## 10 2006 2006-12-31 2006-06-01 2006-05-18
## 11 2012 2012-12-31 2012-08-26 2012-08-12
## 12 2012 2012-12-31 2012-07-18 2012-07-04
## 13 2005 2005-12-31 2005-05-26 2005-05-12
## 14 2005 2005-12-31 2005-05-12 2005-04-28
## 15 2016 2016-12-31 2016-04-25 2016-04-11
Using the countyweather codes I can gather the data for each station in a loop. The code gathers the weather data for each stations and averages them. Then I saved all the data as rds. files because they take a long time to gather. The data is saved in a folder I created called “weather_files/”
for(i in which(has_stations))
{
meteo_df <- meteo_pull_monitors(monitors = stations[[i]]$id,
keep_flags = FALSE,
date_min = outbreak_loc$date_min[i],
date_max = outbreak_loc$date_max[i],
var = c("prcp","snow","snwd","tmax","tmin","tavg"))
coverage_df <- rnoaa::meteo_coverage(meteo_df, verbose = FALSE)
filtered <- countyweather:::filter_coverage(coverage_df, 0.90)
good_monitors <- unique(filtered$id)
filtered_data <- dplyr::filter(meteo_df, id %in% good_monitors)
averaged <- countyweather:::ave_weather(filtered_data)
file_name <- paste0("weather_files/", outbreak_loc$file_id[i], ".rds")
saveRDS(averaged, file_name)
#readRDS(file_name)
}
Now that all of the data is gathered and averaged I can plot the data. The loop will go through the files in order which is in alphabetical order. Therefore I must order my outbreak data frame into alphabetical order too. I will rename this data frame as df_stations for plotting.
## id file_id latitude longitude year_min date_min
## 1 bovenkarspel bovenkarspel 52.70 5.24 1989 1989-01-01
## 2 bronx bronx 40.82 -73.92 2005 2005-01-01
## 3 columbus columbus 39.98 -82.99 2003 2003-01-01
## 4 genesee1 genesee1 43.09 -83.63 2004 2004-01-01
## 5 genesee2 genesee2 43.09 -83.63 2005 2005-01-01
## 6 london london 51.52 -0.10 1979 1979-01-01
## 7 melbourne melbourne -37.86 145.07 1990 1990-01-01
## 8 miyazaki miyazaki 31.89 131.34 1992 1992-01-01
## 9 murcia murcia 37.98 -1.12 1991 1991-01-01
## 10 pamplona pamplona 42.81 -1.65 1996 1996-01-01
## 11 pittsburgh pittsburgh 40.43 -79.98 2002 2002-01-01
## 12 quebec quebec 46.85 -71.34 2002 2002-01-01
## 13 rapid city rapid_city 44.06 -103.22 1995 1995-01-01
## 14 sarpsborg sarpsborg 59.28 11.08 1995 1995-01-01
## 15 sydney sydney -33.85 150.93 2006 2006-01-01
## year_max date_max onset before_onset
## 1 1999 1999-12-31 1999-02-25 1999-02-11
## 2 2015 2015-12-31 2015-07-12 2015-06-28
## 3 2013 2013-12-31 2013-07-09 2013-06-25
## 4 2014 2014-12-31 2014-06-06 2014-05-23
## 5 2015 2015-12-31 2015-05-04 2015-04-20
## 6 1989 1989-12-31 1989-01-01 1988-12-18
## 7 2000 2000-12-31 2000-04-17 2000-04-03
## 8 2002 2002-12-31 2002-07-18 2002-07-04
## 9 2001 2001-12-31 2001-06-26 2001-06-12
## 10 2006 2006-12-31 2006-06-01 2006-05-18
## 11 2012 2012-12-31 2012-08-26 2012-08-12
## 12 2012 2012-12-31 2012-07-18 2012-07-04
## 13 2005 2005-12-31 2005-05-26 2005-05-12
## 14 2005 2005-12-31 2005-05-12 2005-04-28
## 15 2016 2016-12-31 2016-04-25 2016-04-11
This plot is divided by outbreaks in the northern and southern hemisphere. This allows us to see when the outbreaks generally occur in the year.
These plots allow for a quick glance into all the weather variables for each location.
## Warning: Removed 4 rows containing missing values (geom_path).
## Warning: Removed 19 rows containing missing values (geom_path).
## Warning: Removed 27 rows containing missing values (geom_path).
## Warning: Removed 1098 rows containing missing values (geom_path).
## Warning: Removed 7 rows containing missing values (geom_path).
## Warning: Removed 3 rows containing missing values (geom_path).
## Warning: Removed 55 rows containing missing values (geom_path).
I also made a loop to plot graphs and histograms of the data with lines indicating each day before the start of the outbreak for a total of 14 days.A plot of the percentiles is also included.
## Warning: Removed 24 rows containing missing values (geom_path).
## Warning: Removed 27 rows containing missing values (geom_path).